UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r24uv7gVdhbMS/yCs/K/iwW+P8Z77hvCWnEYXVnX740='
WHERE
key_id = '2118fd0e01b285dc624f201a0fcd9a890204252abf6c369c794d08b5f7e84331'
AND (
token = 'r24uv7gVdhbMS/yCs/K/iwW+P8Z77hvCWnEYXVnX740='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)