UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dWPtpM9xqRFqyWrMlBKzG1wuN7Uat1R2qmGpKALcMb8='
WHERE
key_id = '6e8340a188e6aff4b66dd9d34dc482b5b43daae36ac6861478bf387ae5066a7f'
AND (
token = 'dWPtpM9xqRFqyWrMlBKzG1wuN7Uat1R2qmGpKALcMb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)