UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abIP/WdyDjPzbCRd16uJIXsJUOaLY2EcwtcHAb0pBk4='
WHERE
key_id = 'a93aeece7227a97ee123e421b3b3b40d7be5913ce26a7178e28382607765a2cf'
AND (
token = 'abIP/WdyDjPzbCRd16uJIXsJUOaLY2EcwtcHAb0pBk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)