UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LJ8ny/c1NrwuLOEGQML8tZA57KPekKWt1XPpPHOsBk4='
WHERE
key_id = '1e2a2c095d39762876a8f8ef264d9beed17e568df76cbd40ea4696310c1e0310'
AND (
token = 'LJ8ny/c1NrwuLOEGQML8tZA57KPekKWt1XPpPHOsBk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)