UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wkZJJ2Jv/38AYZSqNmyH0rX1btt6CyEnfYhG24uFOc='
WHERE
key_id = 'a9ce78d0b081a146e119aebd72bd22c6a6ca2d12f649aae36aac89f50797cb3c'
AND (
token = '9wkZJJ2Jv/38AYZSqNmyH0rX1btt6CyEnfYhG24uFOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)