UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzZxIUNlDfVsm6TA3i3TCahnzMXqL5JH1lM+KXWAu3I='
WHERE
key_id = '864644dfd7ede9415eaf4139ba7158cad5568f4e0293dd2acfa931439a312ec7'
AND (
token = 'zzZxIUNlDfVsm6TA3i3TCahnzMXqL5JH1lM+KXWAu3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)