UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPYQgWKxupiggHVzeVqMWqKkLwH2X0fKh8tbvss/1yo='
WHERE
key_id = '9238a1550468cafc2b15bf4fe52e4bae262d70ec1f5b077d590483d3586309e0'
AND (
token = 'LPYQgWKxupiggHVzeVqMWqKkLwH2X0fKh8tbvss/1yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)