UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDSaiRWVX26ivCU5SlcVugOX/IvwpjkvHIldknRKiWY='
WHERE
key_id = '31f4610a21af63b3aff0e171f6d4496dbea7da5ef05e529eb83198e2fd00f017'
AND (
token = 'XDSaiRWVX26ivCU5SlcVugOX/IvwpjkvHIldknRKiWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)