UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bvhYTL23ddegkLD3rEZwU3MNfsZwaCzUFpP//aU3vqM='
WHERE
key_id = '50e70798ed480e8013dcc80afd1500a9e9ad9da9e016167f6412223f3a830400'
AND (
token = 'bvhYTL23ddegkLD3rEZwU3MNfsZwaCzUFpP//aU3vqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)