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