UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LmUXXqNW7WbjTgMckEpt0ws3idlmLpULoViW0QxMb/Q='
WHERE
key_id = 'ac665fb147604a8e45c3ebc8e23c002a92769e9f0db7e79edbc56f0044c29663'
AND (
token = 'LmUXXqNW7WbjTgMckEpt0ws3idlmLpULoViW0QxMb/Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)