UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nEBsb1a0KFuc+Mpk8zPNZIS0qX36FpxgwqeehFMBxA0='
WHERE
key_id = '09397b17476cb84f71f741d6cc8f6be8e7baf63dd9feb2647ce59ace7a76dce3'
AND (
token = 'nEBsb1a0KFuc+Mpk8zPNZIS0qX36FpxgwqeehFMBxA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)