UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O6hYPHvSkXtR3k3o3qawcNanvGy807upZr7vZGiZZXo='
WHERE
key_id = 'cad583b0493427dc795f87df6d4a58e23da20a07afee1a4d83a75a6c3dd00fcc'
AND (
token = 'O6hYPHvSkXtR3k3o3qawcNanvGy807upZr7vZGiZZXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)