UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDHfd4gRIXrbRafQzh/wBfTnAw3zvdyGx9FcacxQj1o='
WHERE
key_id = 'c75435b7ae475fffaf707a69a6bc5445895c9a985e116fad452f5258a88f3b88'
AND (
token = 'xDHfd4gRIXrbRafQzh/wBfTnAw3zvdyGx9FcacxQj1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)