UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3+UwgaknJW+1PuksC2Fdx9Jdd9FeE10w0X+j3C9zQOA='
WHERE
key_id = '787a7d2324f87fe30216a54125a039b69ba8c29aa0ba20496427d3ac437627a6'
AND (
token = '3+UwgaknJW+1PuksC2Fdx9Jdd9FeE10w0X+j3C9zQOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)