UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1vy5UQK/s4PS79Ak8mYG7z0zb3V/vrsqKiOtItY6+4w='
WHERE
key_id = 'e112c48d701718b90a2b31285c9446b2caf7434f7e23f2fa4d896ea80270cec8'
AND (
token = '1vy5UQK/s4PS79Ak8mYG7z0zb3V/vrsqKiOtItY6+4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)