UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9zJ1Tt9+tpzjThzomG73c5jOgK6y9GM6GSZW4J4U5g='
WHERE
key_id = 'c2a5d8f997b0f1c0d1d659c14ba21f6a0f8d6d89ac9c1b500fdbc410f2e1fc36'
AND (
token = 'a9zJ1Tt9+tpzjThzomG73c5jOgK6y9GM6GSZW4J4U5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)