UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQlp7djpb4iONULQzm5Hrb/t1Tk9Sp8lvjqIleYoYa0='
WHERE
key_id = 'bb4ccc07298e6e3588eaac36d7fe8b1dd9116e6be2feba23dd7f0d12cae755c6'
AND (
token = 'tQlp7djpb4iONULQzm5Hrb/t1Tk9Sp8lvjqIleYoYa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)