UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bYV/pAj5asXbJWIavXTj5J25z2O2HrG+AP0Ku7Voeno='
WHERE
key_id = 'b523acd2f1da67cd3d876e9a6c89ba54de435d5c5e425795c8c218f36e46ba88'
AND (
token = 'bYV/pAj5asXbJWIavXTj5J25z2O2HrG+AP0Ku7Voeno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)