UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SBUYcJCx1oFxvt1eKoCRd2D97U5HHz9jyDhsIHsVg0w='
WHERE
key_id = '1e8f991d9048292d03aab2a4abf7fa91902fdd3b5874f4773a5a079c3b7aac88'
AND (
token = 'SBUYcJCx1oFxvt1eKoCRd2D97U5HHz9jyDhsIHsVg0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)