UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06KYi8v0MAn9C02W/KeBwiC/oc8Y6TIdZ1J9ypqfLN4='
WHERE
key_id = '7de20a7d600e310ed4786ee732337daf714f71cbdfa77ef79a2c466e8bb11d82'
AND (
token = '06KYi8v0MAn9C02W/KeBwiC/oc8Y6TIdZ1J9ypqfLN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)