UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7xrSc1UhbDVO6nkeN54u4wmAg9N6gE+SRr/YyWIwKAM='
WHERE
key_id = 'ac67df27db47643840e08238add32b3a11a4cb472701eaf9087dae3883ff38c9'
AND (
token = '7xrSc1UhbDVO6nkeN54u4wmAg9N6gE+SRr/YyWIwKAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)