UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1zPfmhO7dPasx3EzgFAU9B70CbRTFfSKYQuo/Rgu7lM='
WHERE
key_id = '58d668d803816aec80c37a8510acc007f9f0a932e9826f40d28ead10cef80eb2'
AND (
token = '1zPfmhO7dPasx3EzgFAU9B70CbRTFfSKYQuo/Rgu7lM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)