UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6tcOY2JPzLdYvHRZQnIfTawsxV6rwQEwTalBfG3Zr8='
WHERE
key_id = '3fce675ce6d3addbb8f022dc8c7050cd25a6c1d1caf20b8fef75926ed2e4eb95'
AND (
token = 'r6tcOY2JPzLdYvHRZQnIfTawsxV6rwQEwTalBfG3Zr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)