UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MZ6x+pUcotzCttje/MwQcElbA5bXNyBeY9tsEVSWlfM='
WHERE
key_id = '72a08df8f83d56974e6a5ee988ef05061349a032eddd75c0a9587bfa988cabfb'
AND (
token = 'MZ6x+pUcotzCttje/MwQcElbA5bXNyBeY9tsEVSWlfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)