UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hT4VPuJUeoL8aJ1Ii2cK8xcpYop0ZrwxMFmPBx8IsyQ='
WHERE
key_id = '3c903cd73d4a55bcc64a584c864ed97cf073e1c71c629b6a876682c89569ac37'
AND (
token = 'hT4VPuJUeoL8aJ1Ii2cK8xcpYop0ZrwxMFmPBx8IsyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)