UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NoFE8u7AFcXJvow6QTI+mBwFUEIS9dg6yV9m9QkhT34='
WHERE
key_id = 'e8a283901bf4e581e185002daae1969b442fbea29dcf685f7cd4c2a61e9a4a27'
AND (
token = 'NoFE8u7AFcXJvow6QTI+mBwFUEIS9dg6yV9m9QkhT34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)