UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThpaPJfT87oSp+asTZRkv6BEefxg1asWIRUSZvb3wn0='
WHERE
key_id = 'e7438b6b3039450c6d56373cad698e1e13ebe58006f970c845982f23395b40cc'
AND (
token = 'ThpaPJfT87oSp+asTZRkv6BEefxg1asWIRUSZvb3wn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)