UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BucLTuY3hJptVcn1YU1ksSQcYa15wVQL3VgycNGSv8Y='
WHERE
key_id = '9bcd0ad5ff45e8fd8af4f76605127dafa87a25ca34a5ea8f53e14d00420b1e0b'
AND (
token = 'BucLTuY3hJptVcn1YU1ksSQcYa15wVQL3VgycNGSv8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)