UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+JLRqHVDRWd5SJtw6i5W26YYqWo8woVyGmdEueXp+BU='
WHERE
key_id = 'a03140ec7b7470ee550de3d827db82a39e67b32adaa4855e3a71e957adf6e6ed'
AND (
token = '+JLRqHVDRWd5SJtw6i5W26YYqWo8woVyGmdEueXp+BU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)