UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HaGUTLIOjSyWxImP2kGrUYpgEluMXmLrHwdEVIbHzdc='
WHERE
key_id = 'f47daef3b60dc87682f7b6639ddad23207a55301212b5e05511ee530502d179b'
AND (
token = 'HaGUTLIOjSyWxImP2kGrUYpgEluMXmLrHwdEVIbHzdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)