UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HrKN2mP0mAgbrDlKl3zNAXcKDCOlV5/o6Hwqfbkgsuk='
WHERE
key_id = '9aaba2be6a24bbdd5099ab62d0358cb7b30a63a58aad612b806a812bff1f9850'
AND (
token = 'HrKN2mP0mAgbrDlKl3zNAXcKDCOlV5/o6Hwqfbkgsuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)