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