UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'laowKDfuXbALhitP8astT5oo+bUcyv1687NwGvLetpI='
WHERE
key_id = '7bdc9acca1c5b75c404a7668e5368e9d0dc84bbe6854a8fc19e6f48b8e10b145'
AND (
token = 'laowKDfuXbALhitP8astT5oo+bUcyv1687NwGvLetpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)